package com.ourteam.system.dao;

import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;

import org.apache.commons.lang.StringUtils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;


/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2018-07-31 15:13:24
  * Warning ! This file will be overwrite when regenerate !
  *
 */
public class SysResourcePropertyOptionDAOQueryBean extends BaseQueryBean {
    public SysResourcePropertyOptionDAOQueryBean() {
        super();
    }

    public SysResourcePropertyOptionDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }

    public SysResourcePropertyOptionDAOQueryBean(BaseQueryBean aQueryBean,
        Map tableReplaceMap) {
        super(aQueryBean, tableReplaceMap);
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria(this);
    }

    public void addIdSelectProperty() {
        addIdSelectProperty("id");
    }

    public void addIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyOptionDAO.Id, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyOptionDAO.Id, "id");
        }
    }

    public void addOrderIndexSelectProperty() {
        addOrderIndexSelectProperty("orderIndex");
    }

    public void addOrderIndexSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyOptionDAO.OrderIndex, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyOptionDAO.OrderIndex,
                "orderIndex");
        }
    }

    public void addRemarksSelectProperty() {
        addRemarksSelectProperty("remarks");
    }

    public void addRemarksSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyOptionDAO.Remarks, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyOptionDAO.Remarks, "remarks");
        }
    }

    public void addStatusSelectProperty() {
        addStatusSelectProperty("status");
    }

    public void addStatusSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyOptionDAO.Status, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyOptionDAO.Status, "status");
        }
    }

    public void addSysResourcePropertyIdSelectProperty() {
        addSysResourcePropertyIdSelectProperty("sysResourcePropertyId");
    }

    public void addSysResourcePropertyIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyOptionDAO.SysResourcePropertyId,
                aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyOptionDAO.SysResourcePropertyId,
                "sysResourcePropertyId");
        }
    }

    public void addValueCodeSelectProperty() {
        addValueCodeSelectProperty("valueCode");
    }

    public void addValueCodeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyOptionDAO.ValueCode, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyOptionDAO.ValueCode,
                "valueCode");
        }
    }

    public void addValueLableSelectProperty() {
        addValueLableSelectProperty("valueLable");
    }

    public void addValueLableSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysResourcePropertyOptionDAO.ValueLable, aAlias);
        } else {
            addSelectProperty(ISysResourcePropertyOptionDAO.ValueLable,
                "valueLable");
        }
    }

    public void addAllSelectProperties() {
        addIdSelectProperty();

        addOrderIndexSelectProperty();

        addRemarksSelectProperty();

        addStatusSelectProperty();

        addSysResourcePropertyIdSelectProperty();

        addValueCodeSelectProperty();

        addValueLableSelectProperty();
    }

    public static class Criteria extends BaseWhereCriterion<SysResourcePropertyOptionDAOQueryBean> {
        protected Criteria(SysResourcePropertyOptionDAOQueryBean aParentObject) {
            super(aParentObject);
        }

        public Criteria andIdIsNull() {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " is null");

            return this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " is not null");

            return this;
        }

        public Criteria andIdIsNotEmpty() {
            addCriterion(ISysResourcePropertyOptionDAO.Id +
                " is not null AND " + ISysResourcePropertyOptionDAO.Id +
                " <> ''");

            return this;
        }

        public Criteria andIdIsEmpty() {
            addCriterion("(" + ISysResourcePropertyOptionDAO.Id +
                " is null OR " + ISysResourcePropertyOptionDAO.Id + " = '')");

            return this;
        }

        public Criteria andIdEqualTo(long value) {
            return andIdEqualTo(Long.valueOf(value));
        }

        public Criteria andIdEqualTo(java.lang.Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " = ", value, "id");

            return this;
        }

        public Criteria andIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Id);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotEqualTo(long value) {
            return andIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToOrIsNull(long value) {
            return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " is null OR " +
                ISysResourcePropertyOptionDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Id);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThan(long value) {
            return andIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " >", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Id);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(long value) {
            return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " >=", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Id);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThan(long value) {
            return andIdLessThan(Long.valueOf(value));
        }

        public Criteria andIdLessThan(java.lang.Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " <", value, "id");

            return this;
        }

        public Criteria andIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Id);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(long value) {
            return andIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " <=", value, "id");

            return this;
        }

        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Id);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdIn(long[] values) {
            if (values.length == 1) {
                return andIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Id + " in", values,
                    "id");

                return this;
            }
        }

        public Criteria andIdNotIn(long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Id + " not in",
                    values, "id");

                return this;
            }
        }

        public Criteria andIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Id + " in", values,
                    "id");

                return this;
            }
        }

        public Criteria andIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Id + " not in",
                    values, "id");

                return this;
            }
        }

        public Criteria andIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Id + " in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Id + " not in",
                    Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andIdBetween(long value1, long value2) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " between", value1,
                value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(long value1, long value2) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " not between",
                value1, value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysResourcePropertyOptionDAO.Id + " not between",
                value1, value2, "id");

            return this;
        }

        public Criteria andOrderIndexIsNull() {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " is null");

            return this;
        }

        public Criteria andOrderIndexIsNotNull() {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex +
                " is not null");

            return this;
        }

        public Criteria andOrderIndexIsNotEmpty() {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex +
                " is not null AND " + ISysResourcePropertyOptionDAO.OrderIndex +
                " <> ''");

            return this;
        }

        public Criteria andOrderIndexIsEmpty() {
            addCriterion("(" + ISysResourcePropertyOptionDAO.OrderIndex +
                " is null OR " + ISysResourcePropertyOptionDAO.OrderIndex +
                " = '')");

            return this;
        }

        public Criteria andOrderIndexEqualTo(Integer value) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " = ",
                value, "orderIndex");

            return this;
        }

        public Criteria andOrderIndexEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.OrderIndex);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOrderIndexEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andOrderIndexNotEqualTo(Integer value) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " <>",
                value, "orderIndex");

            return this;
        }

        public Criteria andOrderIndexNotEqualToOrIsNull(Integer value) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex +
                " is null OR " + ISysResourcePropertyOptionDAO.OrderIndex +
                " <>", value, "orderIndex");

            return this;
        }

        public Criteria andOrderIndexNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.OrderIndex);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOrderIndexNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andOrderIndexGreaterThan(Integer value) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " >",
                value, "orderIndex");

            return this;
        }

        public Criteria andOrderIndexGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.OrderIndex);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOrderIndexGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andOrderIndexGreaterThanOrEqualTo(Integer value) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " >=",
                value, "orderIndex");

            return this;
        }

        public Criteria andOrderIndexGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.OrderIndex);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOrderIndexGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andOrderIndexLessThan(Integer value) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " <",
                value, "orderIndex");

            return this;
        }

        public Criteria andOrderIndexLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.OrderIndex);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOrderIndexLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andOrderIndexLessThanOrEqualTo(Integer value) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " <=",
                value, "orderIndex");

            return this;
        }

        public Criteria andOrderIndexLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.OrderIndex);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOrderIndexLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andOrderIndexIn(List<Integer> values) {
            if (values.size() == 1) {
                return andOrderIndexEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " in",
                    values, "orderIndex");

                return this;
            }
        }

        public Criteria andOrderIndexNotIn(List<Integer> values) {
            if (values.size() == 1) {
                return andOrderIndexNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.OrderIndex +
                    " not in", values, "orderIndex");

                return this;
            }
        }

        public Criteria andOrderIndexIn(Integer[] values) {
            if (values.length == 1) {
                return andOrderIndexEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " in",
                    Arrays.asList(values), "orderIndex");

                return this;
            }
        }

        public Criteria andOrderIndexNotIn(Integer[] values) {
            if (values.length == 1) {
                return andOrderIndexNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.OrderIndex +
                    " not in", Arrays.asList(values), "orderIndex");

                return this;
            }
        }

        public Criteria andOrderIndexIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andOrderIndexNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andOrderIndexBetween(Integer value1, Integer value2) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex + " between",
                value1, value2, "orderIndex");

            return this;
        }

        public Criteria andOrderIndexNotBetween(Integer value1, Integer value2) {
            addCriterion(ISysResourcePropertyOptionDAO.OrderIndex +
                " not between", value1, value2, "orderIndex");

            return this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " is null");

            return this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks +
                " is not null");

            return this;
        }

        public Criteria andRemarksIsNotEmpty() {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks +
                " is not null AND " + ISysResourcePropertyOptionDAO.Remarks +
                " <> ''");

            return this;
        }

        public Criteria andRemarksIsEmpty() {
            addCriterion("(" + ISysResourcePropertyOptionDAO.Remarks +
                " is null OR " + ISysResourcePropertyOptionDAO.Remarks +
                " = '')");

            return this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " = ", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Remarks);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " <>", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks +
                " is null OR " + ISysResourcePropertyOptionDAO.Remarks + " <>",
                value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Remarks);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " >", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Remarks);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " >=", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Remarks);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " <", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Remarks);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " <=", value,
                "remarks");

            return this;
        }

        public Criteria andRemarksLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Remarks);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " not like",
                buffer.toString(), "remarks");

            return this;
        }

        public Criteria andRemarksIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Remarks + " in",
                    values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Remarks + " not in",
                    values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(String[] values) {
            if (values.length == 1) {
                return andRemarksEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Remarks + " in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(String[] values) {
            if (values.length == 1) {
                return andRemarksNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Remarks + " not in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks + " between",
                value1, value2, "remarks");

            return this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyOptionDAO.Remarks +
                " not between", value1, value2, "remarks");

            return this;
        }

        public Criteria andStatusIsNull() {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " is null");

            return this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " is not null");

            return this;
        }

        public Criteria andStatusIsNotEmpty() {
            addCriterion(ISysResourcePropertyOptionDAO.Status +
                " is not null AND " + ISysResourcePropertyOptionDAO.Status +
                " <> ''");

            return this;
        }

        public Criteria andStatusIsEmpty() {
            addCriterion("(" + ISysResourcePropertyOptionDAO.Status +
                " is null OR " + ISysResourcePropertyOptionDAO.Status +
                " = '')");

            return this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " = ", value,
                "status");

            return this;
        }

        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Status);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " <>", value,
                "status");

            return this;
        }

        public Criteria andStatusNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " is null OR " +
                ISysResourcePropertyOptionDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Status);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " >", value,
                "status");

            return this;
        }

        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Status);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " >=", value,
                "status");

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Status);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " <", value,
                "status");

            return this;
        }

        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Status);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " <=", value,
                "status");

            return this;
        }

        public Criteria andStatusLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.Status);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyOptionDAO.Status + " like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyOptionDAO.Status + " not like",
                buffer.toString(), "status");

            return this;
        }

        public Criteria andStatusIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Status + " in",
                    values, "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Status + " not in",
                    values, "status");

                return this;
            }
        }

        public Criteria andStatusIn(String[] values) {
            if (values.length == 1) {
                return andStatusEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Status + " in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(String[] values) {
            if (values.length == 1) {
                return andStatusNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.Status + " not in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " between",
                value1, value2, "status");

            return this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyOptionDAO.Status + " not between",
                value1, value2, "status");

            return this;
        }

        public Criteria andSysResourcePropertyIdIsNull() {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " is null");

            return this;
        }

        public Criteria andSysResourcePropertyIdIsNotNull() {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " is not null");

            return this;
        }

        public Criteria andSysResourcePropertyIdIsNotEmpty() {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " is not null AND " +
                ISysResourcePropertyOptionDAO.SysResourcePropertyId + " <> ''");

            return this;
        }

        public Criteria andSysResourcePropertyIdIsEmpty() {
            addCriterion("(" +
                ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " is null OR " +
                ISysResourcePropertyOptionDAO.SysResourcePropertyId + " = '')");

            return this;
        }

        public Criteria andSysResourcePropertyIdEqualTo(Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " = ", value, "sysResourcePropertyId");

            return this;
        }

        public Criteria andSysResourcePropertyIdEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.SysResourcePropertyId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourcePropertyIdEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourcePropertyIdNotEqualTo(Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " <>", value, "sysResourcePropertyId");

            return this;
        }

        public Criteria andSysResourcePropertyIdNotEqualToOrIsNull(Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " is null OR " +
                ISysResourcePropertyOptionDAO.SysResourcePropertyId + " <>",
                value, "sysResourcePropertyId");

            return this;
        }

        public Criteria andSysResourcePropertyIdNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.SysResourcePropertyId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourcePropertyIdNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourcePropertyIdGreaterThan(Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " >", value, "sysResourcePropertyId");

            return this;
        }

        public Criteria andSysResourcePropertyIdGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.SysResourcePropertyId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourcePropertyIdGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourcePropertyIdGreaterThanOrEqualTo(Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " >=", value, "sysResourcePropertyId");

            return this;
        }

        public Criteria andSysResourcePropertyIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.SysResourcePropertyId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourcePropertyIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourcePropertyIdLessThan(Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " <", value, "sysResourcePropertyId");

            return this;
        }

        public Criteria andSysResourcePropertyIdLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.SysResourcePropertyId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourcePropertyIdLessThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourcePropertyIdLessThanOrEqualTo(Long value) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " <=", value, "sysResourcePropertyId");

            return this;
        }

        public Criteria andSysResourcePropertyIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.SysResourcePropertyId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andSysResourcePropertyIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourcePropertyIdIn(List<Long> values) {
            if (values.size() == 1) {
                return andSysResourcePropertyIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                    " in", values, "sysResourcePropertyId");

                return this;
            }
        }

        public Criteria andSysResourcePropertyIdNotIn(List<Long> values) {
            if (values.size() == 1) {
                return andSysResourcePropertyIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                    " not in", values, "sysResourcePropertyId");

                return this;
            }
        }

        public Criteria andSysResourcePropertyIdIn(Long[] values) {
            if (values.length == 1) {
                return andSysResourcePropertyIdEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                    " in", Arrays.asList(values), "sysResourcePropertyId");

                return this;
            }
        }

        public Criteria andSysResourcePropertyIdNotIn(Long[] values) {
            if (values.length == 1) {
                return andSysResourcePropertyIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                    " not in", Arrays.asList(values), "sysResourcePropertyId");

                return this;
            }
        }

        public Criteria andSysResourcePropertyIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourcePropertyIdNotIn(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andSysResourcePropertyIdBetween(Long value1, Long value2) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " between", value1, value2, "sysResourcePropertyId");

            return this;
        }

        public Criteria andSysResourcePropertyIdNotBetween(Long value1,
            Long value2) {
            addCriterion(ISysResourcePropertyOptionDAO.SysResourcePropertyId +
                " not between", value1, value2, "sysResourcePropertyId");

            return this;
        }

        public Criteria andValueCodeIsNull() {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " is null");

            return this;
        }

        public Criteria andValueCodeIsNotNull() {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode +
                " is not null");

            return this;
        }

        public Criteria andValueCodeIsNotEmpty() {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode +
                " is not null AND " + ISysResourcePropertyOptionDAO.ValueCode +
                " <> ''");

            return this;
        }

        public Criteria andValueCodeIsEmpty() {
            addCriterion("(" + ISysResourcePropertyOptionDAO.ValueCode +
                " is null OR " + ISysResourcePropertyOptionDAO.ValueCode +
                " = '')");

            return this;
        }

        public Criteria andValueCodeEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " = ",
                value, "valueCode");

            return this;
        }

        public Criteria andValueCodeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueCode);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueCodeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueCodeNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " <>",
                value, "valueCode");

            return this;
        }

        public Criteria andValueCodeNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode +
                " is null OR " + ISysResourcePropertyOptionDAO.ValueCode +
                " <>", value, "valueCode");

            return this;
        }

        public Criteria andValueCodeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueCode);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueCodeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueCodeGreaterThan(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " >", value,
                "valueCode");

            return this;
        }

        public Criteria andValueCodeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueCode);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueCodeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueCodeGreaterThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " >=",
                value, "valueCode");

            return this;
        }

        public Criteria andValueCodeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueCode);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueCodeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueCodeLessThan(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " <", value,
                "valueCode");

            return this;
        }

        public Criteria andValueCodeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueCode);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueCodeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueCodeLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " <=",
                value, "valueCode");

            return this;
        }

        public Criteria andValueCodeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueCode);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueCodeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueCodeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " like",
                buffer.toString(), "valueCode");

            return this;
        }

        public Criteria andValueCodeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " not like",
                buffer.toString(), "valueCode");

            return this;
        }

        public Criteria andValueCodeIn(List<String> values) {
            if (values.size() == 1) {
                return andValueCodeEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " in",
                    values, "valueCode");

                return this;
            }
        }

        public Criteria andValueCodeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andValueCodeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.ValueCode +
                    " not in", values, "valueCode");

                return this;
            }
        }

        public Criteria andValueCodeIn(String[] values) {
            if (values.length == 1) {
                return andValueCodeEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " in",
                    Arrays.asList(values), "valueCode");

                return this;
            }
        }

        public Criteria andValueCodeNotIn(String[] values) {
            if (values.length == 1) {
                return andValueCodeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.ValueCode +
                    " not in", Arrays.asList(values), "valueCode");

                return this;
            }
        }

        public Criteria andValueCodeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueCodeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueCodeBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode + " between",
                value1, value2, "valueCode");

            return this;
        }

        public Criteria andValueCodeNotBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueCode +
                " not between", value1, value2, "valueCode");

            return this;
        }

        public Criteria andValueLableIsNull() {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " is null");

            return this;
        }

        public Criteria andValueLableIsNotNull() {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable +
                " is not null");

            return this;
        }

        public Criteria andValueLableIsNotEmpty() {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable +
                " is not null AND " + ISysResourcePropertyOptionDAO.ValueLable +
                " <> ''");

            return this;
        }

        public Criteria andValueLableIsEmpty() {
            addCriterion("(" + ISysResourcePropertyOptionDAO.ValueLable +
                " is null OR " + ISysResourcePropertyOptionDAO.ValueLable +
                " = '')");

            return this;
        }

        public Criteria andValueLableEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " = ",
                value, "valueLable");

            return this;
        }

        public Criteria andValueLableEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueLable);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueLableEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " = ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueLableNotEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " <>",
                value, "valueLable");

            return this;
        }

        public Criteria andValueLableNotEqualToOrIsNull(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable +
                " is null OR " + ISysResourcePropertyOptionDAO.ValueLable +
                " <>", value, "valueLable");

            return this;
        }

        public Criteria andValueLableNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueLable);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueLableNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " <> ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueLableGreaterThan(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " >",
                value, "valueLable");

            return this;
        }

        public Criteria andValueLableGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueLable);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueLableGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " > ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueLableGreaterThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " >=",
                value, "valueLable");

            return this;
        }

        public Criteria andValueLableGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueLable);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueLableGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " >= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueLableLessThan(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " <",
                value, "valueLable");

            return this;
        }

        public Criteria andValueLableLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueLable);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueLableLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " < ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueLableLessThanOrEqualTo(String value) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " <=",
                value, "valueLable");

            return this;
        }

        public Criteria andValueLableLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysResourcePropertyOptionDAO.ValueLable);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andValueLableLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " <= ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueLableLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " like",
                buffer.toString(), "valueLable");

            return this;
        }

        public Criteria andValueLableNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable +
                " not like", buffer.toString(), "valueLable");

            return this;
        }

        public Criteria andValueLableIn(List<String> values) {
            if (values.size() == 1) {
                return andValueLableEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " in",
                    values, "valueLable");

                return this;
            }
        }

        public Criteria andValueLableNotIn(List<String> values) {
            if (values.size() == 1) {
                return andValueLableNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.ValueLable +
                    " not in", values, "valueLable");

                return this;
            }
        }

        public Criteria andValueLableIn(String[] values) {
            if (values.length == 1) {
                return andValueLableEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " in",
                    Arrays.asList(values), "valueLable");

                return this;
            }
        }

        public Criteria andValueLableNotIn(String[] values) {
            if (values.length == 1) {
                return andValueLableNotEqualTo(values[0]);
            } else {
                addCriterion(ISysResourcePropertyOptionDAO.ValueLable +
                    " not in", Arrays.asList(values), "valueLable");

                return this;
            }
        }

        public Criteria andValueLableIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueLableNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andValueLableBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable + " between",
                value1, value2, "valueLable");

            return this;
        }

        public Criteria andValueLableNotBetween(String value1, String value2) {
            addCriterion(ISysResourcePropertyOptionDAO.ValueLable +
                " not between", value1, value2, "valueLable");

            return this;
        }
    }
}
